Make changes to records in a table
1) Select the 'Query' menu and select 'Update'.
2) Add fields to the query design grid that are to be updated or for which to specify criteria:
a) Select the desired field from a table field list in the top half of the Query Design window.
b) Drag the field to the desired column of the design grid in the bottom half of the Query Design window.
c) Release the mouse button. (The field name appears in the Field row, and its table appears in the Table row.)
d) Repeat steps 2)a) through 2)c) for each field to add to the query.
NOTE: Fields can also be added to the query by selecting a field from the drop-down list box in the 'Field' row of the design grid in the bottom half of the Query Design window.
3) If desired, specify criteria in the 'Criteria' and 'or' rows for the fields.
4) In the 'Update To' column, enter the expression or value to change the fields to.
5) Repeat step 4) for each field that is to be updated.